CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

Match3

Matching three values at the same time in three columns Just like Match the ...

Match2

Matching by two values at the same time in two columns Just like Match the ...

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

1FileDB.zip

SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...